update t_onegate_worktype
set C_RECORD_STATUS = 'DANG_THU_LY'
,C_OCCURING_TIME = 'TRINH_KY'
WHERE PK_WORKTYPE IN ('LD_PHONG_TRALAI')
GO
update t_onegate_worktype
set C_OCCURING_TIME = 'THU_LY'
,C_RECORD_STATUS = 'TU_CHOI'
WHERE PK_WORKTYPE IN ('TRA_LAI_HOSO')

update t_onegate_worktype
set C_OCCURING_TIME = 'THU_LY'
,C_RECORD_STATUS = 'TRINH_KY'
WHERE PK_WORKTYPE IN ('TRINH_LD_PHONG_LAN_DAU','TRINH_LD_PHONG_LAN_SAU')

update t_onegate_worktype
set C_OCCURING_TIME = 'TRINH_KY'
,C_RECORD_STATUS = 'TRINH_KY'
WHERE PK_WORKTYPE IN ('TRINH_LD_PHONG_DUYET_LAN_HAI')

update t_onegate_worktype
set C_OCCURING_TIME = 'THU_LY'
,C_RECORD_STATUS = 'MOI_TIEP_NHAN'
WHERE PK_WORKTYPE IN ('YEU_CAU_BO_SUNG')
--
update t_onegate_worktype
set C_OCCURING_TIME = 'TRINH_KY'
,C_RECORD_STATUS = 'DANG_THU_LY'
WHERE PK_WORKTYPE IN ('THAY_DOI_NGUOI_THU_LY','PHAN_CONG')

update t_onegate_worktype
set C_OCCURING_TIME = 'TIEP_NHAN'
,C_RECORD_STATUS = 'DANG_THU_LY_BEN_NGOAI'
WHERE PK_WORKTYPE IN ('NHAN_HO_SO_BO_SUNG')

update t_onegate_worktype
set C_OCCURING_TIME = 'THU_LY'
,C_RECORD_STATUS = 'DANG_THU_LY'
WHERE PK_WORKTYPE 
IN ('TL-TL'
,'NTBNT'
,'TRINH_DK_VPDK_VA_PTNMT'
,'TRICHLUCBANDO'
,'NHAN_THAM_VAN'
,'NHAN_TBRG_TD'
,'NHAN_TBRG'
,'NHAN_TB_THUE'
,'NHAN_KET_QUA_THAM_DINH'
,'KB_THU_NGAN'
,'IN_GIAY_PHEP'
,'DE_NGHI_THAM_VAN'
,'CHUYENSO'
,'CHUYENPHUONG'
,'CHUYEN_TRUNG_TAM_Y_TE'
,'CHUYEN_HS_LUU'
,'XAC_MINH'
,'NOI_DUNG_THONG_BAO_PHAT'
,'NOI_DUNG_THONG_BAO_THUE')

-----
update t_onegate_worktype
set C_OCCURING_TIME = 'TOAN_BO'
,C_RECORD_STATUS = 'DANG_THU_LY'
WHERE PK_WORKTYPE IN('XAC_NHAN_HO_SO')

update t_onegate_worktype
set C_OCCURING_TIME = 'TIEP_NHAN'
,C_RECORD_STATUS = 'DANG_THU_LY'
WHERE PK_WORKTYPE IN('BAN_GIAO')

--- cap nhat lai danh muc cong viec thong bao thue phat
-- can bo thu ly
update t_onegate_worktype
set C_OCCURING_TIME = 'THU_LY'
,C_RECORD_STATUS = 'TRINH_KY'
WHERE PK_WORKTYPE IN('TL_RTB_THUE','TL_RTB_PHAT','TK_KHONG_TB_PHAT')
-- PD -TN phe duyet cuoi cung
update t_onegate_worktype
set C_OCCURING_TIME = 'TRINH_KY'
,C_RECORD_STATUS = 'MOI_TIEP_NHAN'
WHERE PK_WORKTYPE IN('LD_PD_THUE','LD_PD_PHAT')
----
update t_onegate_worktype
set C_OCCURING_TIME = 'TRINH_KY'
,C_RECORD_STATUS = 'DANG_THU_LY'
WHERE PK_WORKTYPE IN('LD_PD_KHONG_PHAT','LD_PHONG_TRALAI_NO_PHAT','LD_PHONG_TRALAI_PHAT','LD_PHONG_TRALAI_THUE')

---1 TRINH 2
update t_onegate_worktype
set C_OCCURING_TIME = 'TRINH_KY'
,C_RECORD_STATUS = 'TRINH_KY'
WHERE PK_WORKTYPE IN('TRINH_LDTB_KHONG_PHAT_L2','TRINH_LDTB_PHAT_L2','TRINH_LDTB_THUE_L2')
-- TN
update t_onegate_worktype
set C_OCCURING_TIME = 'MOI_TIEP_NHAN'
,C_RECORD_STATUS = 'DANG_THU_LY_BEN_NGOAI'
WHERE PK_WORKTYPE IN('NHAN_THONG_BAO_THUE','TN_RTB_THUE','TN_RTB_PHAT')
-- tn _lt
update t_onegate_worktype
set C_OCCURING_TIME = 'DANG_THU_LY_BEN_NGOAI'
,C_RECORD_STATUS = 'DANG_THU_LY'
WHERE PK_WORKTYPE IN('NOP_THUE','NOP_PHAT')